import pandas as pd # for dataframe and manipulation
import numpy as np # for numerical computing
import seaborn as sns # for graphs and data visualization
import matplotlib.pyplot as plt
import plotly.graph_objects as go
netflix = pd.read_csv(r"C:\Users\tiwbrahm\Downloads\netflix.csv")
netflix.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | NaN | United States | September 25, 2021 | 2020 | PG-13 | 90 min | Documentaries | As her father nears the end of his life, filmm... |
| 1 | s2 | TV Show | Blood & Water | NaN | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | International TV Shows, TV Dramas, TV Mysteries | After crossing paths at a party, a Cape Town t... |
netflix.tail(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8805 | s8806 | Movie | Zoom | Peter Hewitt | Tim Allen, Courteney Cox, Chevy Chase, Kate Ma... | United States | January 11, 2020 | 2006 | PG | 88 min | Children & Family Movies, Comedies | Dragged from civilian life, a former superhero... |
| 8806 | s8807 | Movie | Zubaan | Mozez Singh | Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan... | India | March 2, 2019 | 2015 | TV-14 | 111 min | Dramas, International Movies, Music & Musicals | A scrappy but poor boy worms his way into a ty... |
netflix.shape
(8807, 12)
netflix.size
105684
netflix.columns
Index(['show_id', 'type', 'title', 'director', 'cast', 'country', 'date_added',
'release_year', 'rating', 'duration', 'listed_in', 'description'],
dtype='object')
netflix.dtypes
show_id object type object title object director object cast object country object date_added object release_year int64 rating object duration object listed_in object description object dtype: object
netflix.info()
<class 'pandas.core.frame.DataFrame'> RangeIndex: 8807 entries, 0 to 8806 Data columns (total 12 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 show_id 8807 non-null object 1 type 8807 non-null object 2 title 8807 non-null object 3 director 6173 non-null object 4 cast 7982 non-null object 5 country 7976 non-null object 6 date_added 8797 non-null object 7 release_year 8807 non-null int64 8 rating 8803 non-null object 9 duration 8804 non-null object 10 listed_in 8807 non-null object 11 description 8807 non-null object dtypes: int64(1), object(11) memory usage: 825.8+ KB
netflix.describe()
| release_year | |
|---|---|
| count | 8807.000000 |
| mean | 2014.180198 |
| std | 8.819312 |
| min | 1925.000000 |
| 25% | 2013.000000 |
| 50% | 2017.000000 |
| 75% | 2019.000000 |
| max | 2021.000000 |
netflix.describe(include='all')
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | 8807 | 8807 | 8807 | 6173 | 7982 | 7976 | 8797 | 8807.000000 | 8803 | 8804 | 8807 | 8807 |
| unique | 8807 | 2 | 8807 | 4528 | 7692 | 748 | 1767 | NaN | 17 | 220 | 514 | 8775 |
| top | s1 | Movie | Dick Johnson Is Dead | Rajiv Chilaka | David Attenborough | United States | January 1, 2020 | NaN | TV-MA | 1 Season | Dramas, International Movies | Paranormal activity at a lush, abandoned prope... |
| freq | 1 | 6131 | 1 | 19 | 19 | 2818 | 109 | NaN | 3207 | 1793 | 362 | 4 |
| mean | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2014.180198 | NaN | NaN | NaN | NaN |
| std | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 8.819312 | NaN | NaN | NaN | NaN |
| min | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1925.000000 | NaN | NaN | NaN | NaN |
| 25% | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2013.000000 | NaN | NaN | NaN | NaN |
| 50% | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2017.000000 | NaN | NaN | NaN | NaN |
| 75% | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2019.000000 | NaN | NaN | NaN | NaN |
| max | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2021.000000 | NaN | NaN | NaN | NaN |
netflix.nunique()
show_id 8807 type 2 title 8807 director 4528 cast 7692 country 748 date_added 1767 release_year 74 rating 17 duration 220 listed_in 514 description 8775 dtype: int64
# Find Missing Values
netflix.isnull()
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | False | False | False | False | True | False | False | False | False | False | False | False |
| 1 | False | False | False | True | False | False | False | False | False | False | False | False |
| 2 | False | False | False | False | False | True | False | False | False | False | False | False |
| 3 | False | False | False | True | True | True | False | False | False | False | False | False |
| 4 | False | False | False | True | False | False | False | False | False | False | False | False |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 8802 | False | False | False | False | False | False | False | False | False | False | False | False |
| 8803 | False | False | False | True | True | True | False | False | False | False | False | False |
| 8804 | False | False | False | False | False | False | False | False | False | False | False | False |
| 8805 | False | False | False | False | False | False | False | False | False | False | False | False |
| 8806 | False | False | False | False | False | False | False | False | False | False | False | False |
8807 rows × 12 columns
missing = netflix.isnull().sum() # Missing values
missing
show_id 0 type 0 title 0 director 2634 cast 825 country 831 date_added 10 release_year 0 rating 4 duration 3 listed_in 0 description 0 dtype: int64
missing1 = (netflix.isnull().sum()/len(netflix)*100) # Missing values in %
missing1
show_id 0.000000 type 0.000000 title 0.000000 director 29.908028 cast 9.367549 country 9.435676 date_added 0.113546 release_year 0.000000 rating 0.045418 duration 0.034064 listed_in 0.000000 description 0.000000 dtype: float64
# Missing Total with %
Missed = pd.concat([missing,missing1],axis=1,keys=['Total','Missing%'])
Missed
| Total | Missing% | |
|---|---|---|
| show_id | 0 | 0.000000 |
| type | 0 | 0.000000 |
| title | 0 | 0.000000 |
| director | 2634 | 29.908028 |
| cast | 825 | 9.367549 |
| country | 831 | 9.435676 |
| date_added | 10 | 0.113546 |
| release_year | 0 | 0.000000 |
| rating | 4 | 0.045418 |
| duration | 3 | 0.034064 |
| listed_in | 0 | 0.000000 |
| description | 0 | 0.000000 |
# Heatmap to describe Null data in Netflix dataset
sns.heatmap(netflix.isnull())
plt.xticks(rotation=90)
(array([ 0.5, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5, 9.5, 10.5,
11.5]),
[Text(0.5, 0, 'show_id'),
Text(1.5, 0, 'type'),
Text(2.5, 0, 'title'),
Text(3.5, 0, 'director'),
Text(4.5, 0, 'cast'),
Text(5.5, 0, 'country'),
Text(6.5, 0, 'date_added'),
Text(7.5, 0, 'release_year'),
Text(8.5, 0, 'rating'),
Text(9.5, 0, 'duration'),
Text(10.5, 0, 'listed_in'),
Text(11.5, 0, 'description')])
# making copy of dataset for changes
netflix_copy = netflix.copy()
netflix_copy.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | NaN | United States | September 25, 2021 | 2020 | PG-13 | 90 min | Documentaries | As her father nears the end of his life, filmm... |
| 1 | s2 | TV Show | Blood & Water | NaN | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | International TV Shows, TV Dramas, TV Mysteries | After crossing paths at a party, a Cape Town t... |
netflix_copy['director']
0 Kirsten Johnson
1 NaN
2 Julien Leclercq
3 NaN
4 NaN
...
8802 David Fincher
8803 NaN
8804 Ruben Fleischer
8805 Peter Hewitt
8806 Mozez Singh
Name: director, Length: 8807, dtype: object
netflix_copy['director'].fillna('Unknown',inplace=True)
netflix_copy['cast']
0 NaN
1 Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban...
2 Sami Bouajila, Tracy Gotoas, Samuel Jouy, Nabi...
3 NaN
4 Mayur More, Jitendra Kumar, Ranjan Raj, Alam K...
...
8802 Mark Ruffalo, Jake Gyllenhaal, Robert Downey J...
8803 NaN
8804 Jesse Eisenberg, Woody Harrelson, Emma Stone, ...
8805 Tim Allen, Courteney Cox, Chevy Chase, Kate Ma...
8806 Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan...
Name: cast, Length: 8807, dtype: object
netflix_copy['cast'].fillna('Unknown',inplace=True)
netflix_copy['country']
0 United States
1 South Africa
2 NaN
3 NaN
4 India
...
8802 United States
8803 NaN
8804 United States
8805 United States
8806 India
Name: country, Length: 8807, dtype: object
netflix_copy['country'].fillna('Unknown',inplace=True)
netflix_copy.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | month_added | month_name_added | year_added | release_after_years | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | 2021-09-25 | 2020 | PG-13 | 90 min | As her father nears the end of his life, filmm... | Documentaries | NaN | NaN | 9 | September | 2021 | 1 |
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | 2021-09-24 | 2021 | TV-MA | 2 Seasons | After crossing paths at a party, a Cape Town t... | International TV Shows | TV Dramas | TV Mysteries | 9 | September | 2021 | 0 |
netflix_copy.dropna(subset=['date_added','rating','duration'], inplace=True)
netflix_copy.head()
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | September 25, 2021 | 2020 | PG-13 | 90 min | Documentaries | As her father nears the end of his life, filmm... |
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | International TV Shows, TV Dramas, TV Mysteries | After crossing paths at a party, a Cape Town t... |
| 2 | s3 | TV Show | Ganglands | Julien Leclercq | Sami Bouajila, Tracy Gotoas, Samuel Jouy, Nabi... | Unknown | September 24, 2021 | 2021 | TV-MA | 1 Season | Crime TV Shows, International TV Shows, TV Act... | To protect his family from a powerful drug lor... |
| 3 | s4 | TV Show | Jailbirds New Orleans | Unknown | Unknown | Unknown | September 24, 2021 | 2021 | TV-MA | 1 Season | Docuseries, Reality TV | Feuds, flirtations and toilet talk go down amo... |
| 4 | s5 | TV Show | Kota Factory | Unknown | Mayur More, Jitendra Kumar, Ranjan Raj, Alam K... | India | September 24, 2021 | 2021 | TV-MA | 2 Seasons | International TV Shows, Romantic TV Shows, TV ... | In a city of coaching centers known to train I... |
# Handling with duplicate rows
netflix_copy[netflix_copy.duplicated()] # To show duplicate rows
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description |
|---|
netflix_copy.duplicated().sum() # Count of duplicate rows
0
netflix_copy.shape # Size after cleaning
(8790, 12)
netflix_copy.type.unique()
array(['Movie', 'TV Show'], dtype=object)
netflix_movies = netflix_copy[netflix_copy['type'] == 'Movie'].copy()
netflix_shows = netflix_copy[netflix_copy['type'] == 'TV Show'].copy()
netflix_movies.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | month_added | month_name_added | year_added | release_after_years | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | 2021-09-25 | 2020 | PG-13 | 90 min | As her father nears the end of his life, filmm... | Documentaries | NaN | NaN | 9 | September | 2021 | 1 |
| 6 | s7 | Movie | My Little Pony: A New Generation | Robert Cullen, José Luis Ucha | Vanessa Hudgens, Kimiko Glenn, James Marsden, ... | Unknown | 2021-09-24 | 2021 | PG | 91 min | Equestria's divided. But a bright-eyed hero be... | Children & Family Movies | NaN | NaN | 9 | September | 2021 | 0 |
netflix_shows.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | International TV Shows, TV Dramas, TV Mysteries | After crossing paths at a party, a Cape Town t... |
| 2 | s3 | TV Show | Ganglands | Julien Leclercq | Sami Bouajila, Tracy Gotoas, Samuel Jouy, Nabi... | Unknown | September 24, 2021 | 2021 | TV-MA | 1 Season | Crime TV Shows, International TV Shows, TV Act... | To protect his family from a powerful drug lor... |
netflix_movies['duration'] = netflix_movies.duration.str.replace(' min','').astype(int)
netflix_shows.rename(columns={'duration':'season'},inplace=True)
netflix_shows.head(5)
| show_id | type | title | director | cast | country | date_added | release_year | rating | season | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | International TV Shows, TV Dramas, TV Mysteries | After crossing paths at a party, a Cape Town t... |
| 2 | s3 | TV Show | Ganglands | Julien Leclercq | Sami Bouajila, Tracy Gotoas, Samuel Jouy, Nabi... | Unknown | September 24, 2021 | 2021 | TV-MA | 1 Season | Crime TV Shows, International TV Shows, TV Act... | To protect his family from a powerful drug lor... |
| 3 | s4 | TV Show | Jailbirds New Orleans | Unknown | Unknown | Unknown | September 24, 2021 | 2021 | TV-MA | 1 Season | Docuseries, Reality TV | Feuds, flirtations and toilet talk go down amo... |
| 4 | s5 | TV Show | Kota Factory | Unknown | Mayur More, Jitendra Kumar, Ranjan Raj, Alam K... | India | September 24, 2021 | 2021 | TV-MA | 2 Seasons | International TV Shows, Romantic TV Shows, TV ... | In a city of coaching centers known to train I... |
| 5 | s6 | TV Show | Midnight Mass | Mike Flanagan | Kate Siegel, Zach Gilford, Hamish Linklater, H... | Unknown | September 24, 2021 | 2021 | TV-MA | 1 Season | TV Dramas, TV Horror, TV Mysteries | The arrival of a charismatic young priest brin... |
netflix_shows["season"] = netflix_shows.season.str.replace(" Seasons",'')
netflix_shows["season"] = netflix_shows.season.str.replace(" Season",'').astype(int)
netflix_shows.head()
| show_id | type | title | director | cast | country | date_added | release_year | rating | season | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 | International TV Shows, TV Dramas, TV Mysteries | After crossing paths at a party, a Cape Town t... |
| 2 | s3 | TV Show | Ganglands | Julien Leclercq | Sami Bouajila, Tracy Gotoas, Samuel Jouy, Nabi... | Unknown | September 24, 2021 | 2021 | TV-MA | 1 | Crime TV Shows, International TV Shows, TV Act... | To protect his family from a powerful drug lor... |
| 3 | s4 | TV Show | Jailbirds New Orleans | Unknown | Unknown | Unknown | September 24, 2021 | 2021 | TV-MA | 1 | Docuseries, Reality TV | Feuds, flirtations and toilet talk go down amo... |
| 4 | s5 | TV Show | Kota Factory | Unknown | Mayur More, Jitendra Kumar, Ranjan Raj, Alam K... | India | September 24, 2021 | 2021 | TV-MA | 2 | International TV Shows, Romantic TV Shows, TV ... | In a city of coaching centers known to train I... |
| 5 | s6 | TV Show | Midnight Mass | Mike Flanagan | Kate Siegel, Zach Gilford, Hamish Linklater, H... | Unknown | September 24, 2021 | 2021 | TV-MA | 1 | TV Dramas, TV Horror, TV Mysteries | The arrival of a charismatic young priest brin... |
netflix_copy.rating.unique()
array(['PG-13', 'TV-MA', 'PG', 'TV-14', 'TV-PG', 'TV-Y', 'TV-Y7', 'R',
'TV-G', 'G', 'NC-17', 'NR', 'TV-Y7-FV', 'UR'], dtype=object)
plt.figure(figsize=(15,7))
sns.countplot(netflix_copy,x=netflix_copy['rating'],hue=netflix_copy['type'])
plt.show()
Observation :
#No. of movies released every year
netflix_copy.groupby(['release_year'])['release_year'].count().sort_values(ascending=False)
release_year
2018 1146
2019 1030
2017 1030
2020 953
2016 901
...
1959 1
1961 1
1947 1
1966 1
1925 1
Name: release_year, Length: 74, dtype: int64
plt.figure(figsize=(35,12))
sns.countplot(netflix_copy,x = netflix_copy.release_year,hue=netflix_copy.type)
plt.xticks(rotation=90)
plt.show()
Observation:
netflix_copy.type.value_counts().to_frame('Value_count')
| Value_count | |
|---|---|
| type | |
| Movie | 6126 |
| TV Show | 2664 |
sns.countplot(x=netflix_copy['type'])
plt.xticks(rotation=90)
(array([0, 1]), [Text(0, 0, 'Movie'), Text(1, 0, 'TV Show')])
# Pie chart to show value in % for most watched
type_show = ['Movie','TV Show']
Value_count = [6126,2663]
plt.pie(Value_count,labels=type_show,autopct="%2.2f%%")
plt.legend(title='Most watched shows on the Netflix')
<matplotlib.legend.Legend at 0x1700d5e8130>
netflix_copy.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | September 25, 2021 | 2020 | PG-13 | 90 min | Documentaries | As her father nears the end of his life, filmm... |
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | International TV Shows, TV Dramas, TV Mysteries | After crossing paths at a party, a Cape Town t... |
netflix.groupby("type")["rating"].agg(pd.Series.mode)
type Movie TV-MA TV Show TV-MA Name: rating, dtype: object
new_genre = netflix_copy['listed_in'].str.split(",",n = 2)
new_genre
0 [Documentaries]
1 [International TV Shows, TV Dramas, TV Myste...
2 [Crime TV Shows, International TV Shows, TV ...
3 [Docuseries, Reality TV]
4 [International TV Shows, Romantic TV Shows, ...
...
8802 [Cult Movies, Dramas, Thrillers]
8803 [Kids' TV, Korean TV Shows, TV Comedies]
8804 [Comedies, Horror Movies]
8805 [Children & Family Movies, Comedies]
8806 [Dramas, International Movies, Music & Music...
Name: listed_in, Length: 8790, dtype: object
netflix_copy['Genre 1'] = new_genre.str.get(0)
netflix_copy['Genre 2'] = new_genre.str.get(1)
netflix_copy['Genre 3'] = new_genre.str.get(2)
netflix_copy.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | Genre 1 | Genre 2 | Genre 3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | September 25, 2021 | 2020 | PG-13 | 90 min | Documentaries | As her father nears the end of his life, filmm... | Documentaries | NaN | NaN |
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | International TV Shows, TV Dramas, TV Mysteries | After crossing paths at a party, a Cape Town t... | International TV Shows | TV Dramas | TV Mysteries |
netflix_copy['Genre 1'].describe(include=all)
count 8790 unique 36 top Dramas freq 1599 Name: Genre 1, dtype: object
netflix_copy['Genre 2'].describe(include=all)
count 6778 unique 37 top International Movies freq 1722 Name: Genre 2, dtype: object
netflix_copy['Genre 3'].describe(include=all)
count 3726 unique 33 top International Movies freq 902 Name: Genre 3, dtype: object
netflix_copy.drop('listed_in',axis = 1,inplace = True)
netflix_copy.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | September 25, 2021 | 2020 | PG-13 | 90 min | As her father nears the end of his life, filmm... | Documentaries | NaN | NaN |
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | After crossing paths at a party, a Cape Town t... | International TV Shows | TV Dramas | TV Mysteries |
netflix_copy.duplicated().sum()
0
netflix_copy.groupby(['Genre 1'])['release_year'].count().sort_values(ascending = False)
Genre 1 Dramas 1599 Comedies 1210 Action & Adventure 859 Documentaries 829 International TV Shows 773 Children & Family Movies 605 Crime TV Shows 399 Kids' TV 385 Stand-Up Comedy 334 Horror Movies 275 British TV Shows 252 Docuseries 220 Anime Series 174 International Movies 128 Reality TV 120 TV Comedies 119 Classic Movies 80 TV Dramas 67 Thrillers 65 Movies 53 TV Action & Adventure 39 Stand-Up Comedy & Talk Shows 34 Romantic TV Shows 32 Anime Features 21 Classic & Cult TV 20 Independent Movies 20 Music & Musicals 18 TV Shows 16 Sci-Fi & Fantasy 13 Cult Movies 12 TV Horror 11 Romantic Movies 3 Spanish-Language TV Shows 2 Sports Movies 1 TV Sci-Fi & Fantasy 1 LGBTQ Movies 1 Name: release_year, dtype: int64
netflix_copy.groupby(['Genre 2'])['release_year'].count().sort_values(ascending = False)
Genre 2 International Movies 1722 Dramas 758 Independent Movies 576 International TV Shows 475 Comedies 452 TV Dramas 320 TV Comedies 263 Romantic TV Shows 239 Thrillers 232 Romantic Movies 171 Docuseries 153 Music & Musicals 148 Korean TV Shows 131 Sci-Fi & Fantasy 112 Sports Movies 100 Reality TV 95 TV Action & Adventure 83 Horror Movies 75 Crime TV Shows 70 Spanish-Language TV Shows 65 Kids' TV 62 Faith & Spirituality 54 Anime Features 50 Cult Movies 45 Science & Nature TV 45 LGBTQ Movies 45 Documentaries 39 Children & Family Movies 32 Classic Movies 30 TV Horror 30 TV Mysteries 22 TV Sci-Fi & Fantasy 21 Teen TV Shows 21 Stand-Up Comedy & Talk Shows 16 TV Thrillers 11 Stand-Up Comedy 9 Classic & Cult TV 6 Name: release_year, dtype: int64
netflix_copy.groupby(['Genre 3'])['release_year'].count().sort_values(ascending = False)
Genre 3 International Movies 902 Romantic Movies 442 TV Dramas 375 Thrillers 280 Music & Musicals 209 TV Comedies 191 Independent Movies 160 Sports Movies 118 Sci-Fi & Fantasy 118 Spanish-Language TV Shows 106 International TV Shows 101 Romantic TV Shows 99 TV Mysteries 76 Dramas 69 TV Sci-Fi & Fantasy 61 LGBTQ Movies 56 Teen TV Shows 48 Science & Nature TV 47 TV Thrillers 46 TV Action & Adventure 45 Reality TV 40 TV Horror 34 Docuseries 21 Korean TV Shows 20 Cult Movies 14 Comedies 12 Faith & Spirituality 11 Horror Movies 7 Classic Movies 6 Stand-Up Comedy & Talk Shows 6 Children & Family Movies 4 Kids' TV 1 Documentaries 1 Name: release_year, dtype: int64
netflix_copy.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | September 25, 2021 | 2020 | PG-13 | 90 min | As her father nears the end of his life, filmm... | Documentaries | NaN | NaN |
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | After crossing paths at a party, a Cape Town t... | International TV Shows | TV Dramas | TV Mysteries |
netflix_copy.dtypes
show_id object type object title object director object cast object country object date_added datetime64[ns] release_year int64 rating object duration object description object Genre 1 object Genre 2 object Genre 3 object month_added int32 month_name_added object year_added int32 dtype: object
netflix_tv = netflix_copy[netflix_copy["type"] == "TV Show"]
netflix_movies = netflix_copy[netflix_copy["type"] == "Movie"]
netflix_copy["date_added"] = pd.to_datetime(netflix_copy['date_added'],format='mixed')
netflix_copy['month_added']=netflix_copy['date_added'].dt.month
netflix_copy['month_name_added']=netflix_copy['date_added'].dt.month_name()
netflix_copy['year_added'] = netflix_copy['date_added'].dt.year
netflix_copy.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | month_added | month_name_added | year_added | release_after_years | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | 2021-09-25 | 2020 | PG-13 | 90 min | As her father nears the end of his life, filmm... | Documentaries | NaN | NaN | 9 | September | 2021 | 1 |
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | 2021-09-24 | 2021 | TV-MA | 2 Seasons | After crossing paths at a party, a Cape Town t... | International TV Shows | TV Dramas | TV Mysteries | 9 | September | 2021 | 0 |
netflix_copy.month_name_added.value_counts().to_frame('Value_count')
| Value_count | |
|---|---|
| month_name_added | |
| July | 827 |
| December | 812 |
| September | 769 |
| April | 763 |
| October | 760 |
| August | 754 |
| March | 741 |
| January | 737 |
| June | 728 |
| November | 705 |
| May | 632 |
| February | 562 |
sns.countplot(x=netflix_copy['month_name_added'],orient='v')
plt.xticks(rotation=90)
(array([ 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11]), [Text(0, 0, 'September'), Text(1, 0, 'August'), Text(2, 0, 'July'), Text(3, 0, 'June'), Text(4, 0, 'May'), Text(5, 0, 'April'), Text(6, 0, 'March'), Text(7, 0, 'February'), Text(8, 0, 'January'), Text(9, 0, 'December'), Text(10, 0, 'November'), Text(11, 0, 'October')])
netflix_content = netflix_copy[['month_added','month_name_added']].value_counts().reset_index().rename(columns = {
0 : 'count'}).sort_values('month_added').drop('month_added',axis=1)
netflix_content['percent'] = netflix_content['count'].apply(lambda x : 100*x/sum(netflix_content['count']))
netflix_tv2 = netflix_tv[['month_added','month_name_added']].value_counts().reset_index().rename(columns = {
0 : 'count'}).sort_values('month_added').drop('month_added',axis=1)
netflix_tv2['percent'] = netflix_tv2['count'].apply(lambda x : 100*x/sum(netflix_tv2['count']))
netflix_movies2 = netflix_movies[['month_added','month_name_added']].value_counts().reset_index().rename(columns = {
0 : 'count'}).sort_values('month_added').drop('month_added',axis=1)
netflix_movies2['percent'] = netflix_movies2['count'].apply(lambda x : 100*x/sum(netflix_movies2['count']))
t1 = go.Scatter(x=netflix_movies2['month_name_added'], y=netflix_movies2["count"], name="Movies", marker=dict(color="#a678de"))
t2 = go.Scatter(x=netflix_tv2['month_name_added'], y=netflix_tv2["count"], name="TV Shows", marker=dict(color="#6ad49b"))
t3 = go.Scatter(x=netflix_content['month_name_added'], y=netflix_content["count"], name="Total Contents", marker=dict(color="Brown"))
data = [t1, t2, t3]
layout = go.Layout(title="Content added over the years", legend=dict(x=0.1, y=1.1, orientation="h"))
fig = go.Figure(data, layout=layout)
fig.show()
Observation :
netflix_copy.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | September 25, 2021 | 2020 | PG-13 | 90 min | As her father nears the end of his life, filmm... | Documentaries | NaN | NaN |
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | After crossing paths at a party, a Cape Town t... | International TV Shows | TV Dramas | TV Mysteries |
netflix_copy['Genre 1'].describe(include=all)
count 8790 unique 36 top Dramas freq 1599 Name: Genre 1, dtype: object
netflix_copy['Genre 2'].describe(include=all)
count 6778 unique 37 top International Movies freq 1722 Name: Genre 2, dtype: object
netflix_copy['Genre 3'].describe(include=all)
count 3726 unique 33 top International Movies freq 902 Name: Genre 3, dtype: object
# Showing most watched genre on Pie Chart
genre_types = ['Genre 1','Genre 2','Genre 3']
Value_count = [8790,6778,3726]
plt.pie(Value_count, labels = genre_types, autopct="%2.2f%%")
plt.legend(title='Most watched genre on the Netflix')
plt.show()
netflix_copy.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | month_added | month_name_added | year_added | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | 2021-09-25 | 2020 | PG-13 | 90 min | As her father nears the end of his life, filmm... | Documentaries | NaN | NaN | 9 | September | 2021 |
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | 2021-09-24 | 2021 | TV-MA | 2 Seasons | After crossing paths at a party, a Cape Town t... | International TV Shows | TV Dramas | TV Mysteries | 9 | September | 2021 |
netflix_copy[['release_year','year_added']]
| release_year | year_added | |
|---|---|---|
| 0 | 2020 | 2021 |
| 1 | 2021 | 2021 |
| 2 | 2021 | 2021 |
| 3 | 2021 | 2021 |
| 4 | 2021 | 2021 |
| ... | ... | ... |
| 8802 | 2007 | 2019 |
| 8803 | 2018 | 2019 |
| 8804 | 2009 | 2019 |
| 8805 | 2006 | 2020 |
| 8806 | 2015 | 2019 |
8790 rows × 2 columns
netflix_copy['release_after_years'] = netflix_copy.year_added - netflix_copy.release_year
#Showing displot chart for time it took for movies to get publish on netflix after release
sns.displot(netflix_copy, x="release_after_years", binwidth=5)
<seaborn.axisgrid.FacetGrid at 0x170119baf80>
netflix_copy.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | September 25, 2021 | 2020 | PG-13 | 90 min | As her father nears the end of his life, filmm... | Documentaries | NaN | NaN |
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | After crossing paths at a party, a Cape Town t... | International TV Shows | TV Dramas | TV Mysteries |
netflix_copy[netflix_copy['title'].isin(['Sex Education'])]
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32 | s33 | TV Show | Sex Education | Unknown | Asa Butterfield, Gillian Anderson, Ncuti Gatwa... | United Kingdom | September 17, 2021 | 2020 | TV-MA | 3 Seasons | Insecure Otis has all the answers when it come... | British TV Shows | International TV Shows | TV Comedies |
Obeservation:
netflix_copy.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | September 25, 2021 | 2020 | PG-13 | 90 min | As her father nears the end of his life, filmm... | Documentaries | NaN | NaN |
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | After crossing paths at a party, a Cape Town t... | International TV Shows | TV Dramas | TV Mysteries |
netflix[(netflix['type'] == 'Movie' ) & (netflix['release_year'] == 2004)]
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53 | s54 | Movie | InuYasha the Movie 4: Fire on the Mystic Island | Toshiya Shinohara | Kappei Yamaguchi, Satsuki Yukino, Koji Tsujita... | Japan | September 15, 2021 | 2004 | TV-PG | 88 min | Action & Adventure, Anime Features, Internatio... | Ai, a young half-demon who has escaped from Ho... |
| 63 | s64 | Movie | Naruto the Movie: Ninja Clash in the Land of Snow | Tensai Okamura | Junko Takeuchi, Noriaki Sugiyama, Chie Nakamur... | Japan | September 15, 2021 | 2004 | TV-PG | 83 min | Action & Adventure, Anime Features, Internatio... | Naruto, Sasuke and Sakura learn they'll be pro... |
| 127 | s128 | Movie | A Cinderella Story | Mark Rosman | Hilary Duff, Chad Michael Murray, Jennifer Coo... | United States, Canada | September 1, 2021 | 2004 | PG | 95 min | Children & Family Movies, Comedies | Teen Sam meets the boy of her dreams at a danc... |
| 200 | s201 | Movie | Krishna Cottage | Santram Varma | Sohail Khan, Isha Koppikar, Natassha, Rati Agn... | India | August 27, 2021 | 2004 | TV-14 | 124 min | Action & Adventure, Horror Movies, Internation... | True love is put to the test when another woma... |
| 351 | s352 | Movie | Team America: World Police | Trey Parker | Trey Parker, Matt Stone, Kristen Miller, Masas... | United States, Germany | August 1, 2021 | 2004 | R | 98 min | Action & Adventure, Comedies, Cult Movies | In this musical satire, an all-marionette poli... |
| 357 | s358 | Movie | The Machinist | Brad Anderson | Christian Bale, Jennifer Jason Leigh, Aitana S... | Spain, France, United Kingdom, United States | August 1, 2021 | 2004 | R | 102 min | Dramas, Independent Movies, Thrillers | Haunted and gaunt after a prolonged bout of in... |
| 652 | s653 | Movie | Osuofia in London II | Kingsley Ogoro | Nkem Owoh, Mara Derwent, Francis Odega, Cynthi... | NaN | June 22, 2021 | 2004 | TV-14 | 70 min | Comedies, Dramas, International Movies | After collecting his brother's inheritance, Os... |
| 799 | s800 | Movie | Million Dollar Baby | Clint Eastwood | Clint Eastwood, Hilary Swank, Morgan Freeman, ... | United States | June 2, 2021 | 2004 | PG-13 | 133 min | Dramas, Sports Movies | When a cantankerous trainer mentors a persiste... |
| 809 | s810 | Movie | Starsky & Hutch | Todd Phillips | Ben Stiller, Owen Wilson, Vince Vaughn, Juliet... | United States | June 2, 2021 | 2004 | PG-13 | 101 min | Action & Adventure, Comedies | New undercover cop partners Starsky and Hutch ... |
| 891 | s892 | Movie | Layer Cake | Matthew Vaughn | Daniel Craig, Colm Meaney, Kenneth Cranham, Si... | United Kingdom | May 13, 2021 | 2004 | R | 105 min | Independent Movies, International Movies, Thri... | A suave, steely-eyed London cocaine dealer's r... |
| 981 | s982 | Movie | G.O.R.A | Ömer Faruk Sorak | Cem Yılmaz, Rasim Öztekin, Özkan Uğur, İdil Fı... | Turkey | April 23, 2021 | 2004 | TV-MA | 123 min | Action & Adventure, Comedies, International Mo... | Carpet dealer and UFO photo forger Arif is abd... |
| 1020 | s1021 | Movie | Madness in the Desert | Satyajit Bhatkal | Aamir Khan, Ashutosh Gowariker | India | April 17, 2021 | 2004 | TV-14 | 141 min | Documentaries, International Movies | The story of making "Lagaan," one of the mille... |
| 1521 | s1522 | Movie | Rabun | Yasmin Ahmad | M. Rajoli, Kartina Aziz, Rozie Rashid, Irwan I... | Malaysia | December 18, 2020 | 2004 | TV-PG | 85 min | Dramas, Independent Movies, International Movies | A free-spirited couple leave the city to retir... |
| 1673 | s1674 | Movie | Black Friday | Anurag Kashyap | Pavan Malhotra, Kay Kay Menon, Aditya Srivasta... | India | November 19, 2020 | 2004 | TV-MA | 162 min | Dramas, International Movies | This docudrama based on the same-titled book t... |
| 1858 | s1859 | Movie | Fida | Ken Ghosh | Fardeen Khan, Kareena Kapoor, Shahid Kapoor, K... | India | October 13, 2020 | 2004 | TV-14 | 117 min | International Movies, Romantic Movies, Thrillers | An all-around nice guy finds himself in a dang... |
| 1876 | s1877 | Movie | Palermo Hollywood | Eduardo Pinto | Brian Maya, Matías Desiderio, Manuela Pal, Azu... | Argentina | October 8, 2020 | 2004 | TV-MA | 106 min | Dramas, International Movies | A pair of petty criminals from different backg... |
| 2439 | s2440 | Movie | The Student Cop | Wael Ihsan | Karim Abdel Aziz, Hassan Hosny, Ghada Adel, Ma... | Egypt | June 2, 2020 | 2004 | TV-14 | 111 min | Action & Adventure, Comedies, International Mo... | Sent undercover to investigate suspicious acti... |
| 2510 | s2511 | Movie | The Beach Loafer | Ali Ragab | Ahmed Helmy, Yasmin Abdulaziz, Mahmoud Abdel M... | Egypt | May 19, 2020 | 2004 | TV-14 | 112 min | Comedies, International Movies | A wedding singer and his friends try to prove ... |
| 3002 | s3003 | Movie | Whisky | Pablo Stoll, Juan Pablo Rebella | Andrés Pazos, Mirella Pascual, Jorge Bolani, J... | Uruguay, Argentina, Germany, Spain | January 22, 2020 | 2004 | TV-MA | 98 min | Comedies, Dramas, International Movies | To impress family, a factory owner pretends to... |
| 3142 | s3143 | Movie | Lakshya | Farhan Akhtar | Amitabh Bachchan, Hrithik Roshan, Preity Zinta... | India | December 15, 2019 | 2004 | TV-PG | 185 min | Action & Adventure, Dramas, International Movies | After dropping out of the army, a spoiled teen... |
| 3544 | s3545 | Movie | Spookley the Square Pumpkin | Bernie Denk | Sonja Ball, Craig Francis, Rick Jones, Michel ... | United States | September 1, 2019 | 2004 | G | 47 min | Children & Family Movies | When a storm terrorizes his patch, a pumpkin c... |
| 3649 | s3650 | Movie | The Twins Effect II | Corey Yuen, Patrick Leung | Donnie Yen, Jaycee Chan, Charlene Choi, Gillia... | Hong Kong, China | July 21, 2019 | 2004 | TV-14 | 106 min | Action & Adventure, Comedies, International Mo... | An empress rules over a land where men are sub... |
| 4102 | s4103 | Movie | Chameli | Sudhir Mishra | Kareena Kapoor, Rahul Bose, Rinke Khanna, Yash... | India | February 15, 2019 | 2004 | TV-14 | 102 min | Dramas, International Movies | While taking shelter from a Mumbai monsoon, an... |
| 4952 | s4953 | Movie | Main Hoon Na | Farah Khan | Shah Rukh Khan, Sunil Shetty, Sushmita Sen, Za... | India | April 1, 2018 | 2004 | TV-14 | 171 min | Action & Adventure, Comedies, Dramas | Major Ram Prasad Sharma yearns to see project ... |
| 5014 | s5015 | Movie | Swades | Ashutosh Gowariker | Shah Rukh Khan, Gayatri Joshi, Kishori Balal, ... | India | March 1, 2018 | 2004 | TV-PG | 185 min | Dramas, International Movies | An Americanized NASA scientist returns to his ... |
| 5019 | s5020 | Movie | Trailer Park Boys: Xmas Special | Mike Clattenburg | John Paul Tremblay, Robb Wells, John Dunsworth... | Canada | March 1, 2018 | 2004 | TV-MA | 46 min | Movies | See what Sunnyvale Trailer Park was like back ... |
| 5021 | s5022 | Movie | Yuva | Mani Ratnam | Ajay Devgn, Abhishek Bachchan, Vivek Oberoi, E... | India | March 1, 2018 | 2004 | TV-14 | 160 min | Dramas, International Movies | An accident on a bridge ties together three yo... |
| 6018 | s6019 | Movie | 50 First Dates | Peter Segal | Adam Sandler, Drew Barrymore, Rob Schneider, S... | United States | December 1, 2020 | 2004 | PG-13 | 99 min | Comedies, Romantic Movies | After falling for a pretty art teacher who has... |
| 6107 | s6108 | Movie | Aitraaz | Abbas Alibhai Burmawalla, Mastan Alibhai Burma... | Akshay Kumar, Kareena Kapoor, Priyanka Chopra,... | India | March 1, 2018 | 2004 | TV-14 | 153 min | International Movies, Music & Musicals, Romant... | A happily married business executive is forced... |
| 6222 | s6223 | Movie | Balto 3: Wings of Change | Phil Weinstein | Maurice LaMarche, Sean Astin, Keith Carradine,... | United States | April 1, 2018 | 2004 | G | 78 min | Children & Family Movies | A pilot challenges Balto's son Kodi and his sl... |
| 6283 | s6284 | Movie | Benji: Off the Leash | Joe Camp | Nick Whitaker, Chris Kendrick, Randall Newsome... | United States | March 6, 2018 | 2004 | PG | 100 min | Children & Family Movies, Dramas | Benji is back in this charming story that's to... |
| 6480 | s6481 | Movie | Christmas with the Kranks | Joe Roth | Tim Allen, Jamie Lee Curtis, Dan Aykroyd, Erik... | United States | January 1, 2019 | 2004 | PG | 99 min | Children & Family Movies, Comedies | When Luther Krank and his wife opt to skip Chr... |
| 6540 | s6541 | Movie | Crash | Paul Haggis | Sandra Bullock, Don Cheadle, Matt Dillon, Jenn... | United States, Germany | October 1, 2019 | 2004 | R | 112 min | Dramas, Independent Movies | In post-Sept. 11 Los Angeles, tensions erupt w... |
| 6602 | s6603 | Movie | Devrai | Sumitra Bhave, Sunil Sukthankar | Atul Kulkarni, Sonali Kulkarni, Tushar Dalvi, ... | India | January 1, 2018 | 2004 | TV-PG | 123 min | Dramas, International Movies | After science student Shesh Shahi – a shy ecce... |
| 6669 | s6670 | Movie | Ek Hasina Thi | Sriram Raghavan | Saif Ali Khan, Urmila Matondkar, Seema Biswas,... | India | August 1, 2019 | 2004 | TV-MA | 134 min | Dramas, International Movies, Thrillers | Imprisoned for underworld crimes she didn’t co... |
| 6928 | s6929 | Movie | Harold & Kumar Go to White Castle | Danny Leiner | John Cho, Kal Penn, Paula Garcés, Neil Patrick... | United States, Canada, Germany | January 1, 2020 | 2004 | R | 88 min | Comedies, Cult Movies | Buddies Harold and Kumar set out to satisfy a ... |
| 6957 | s6958 | Movie | Hellboy | Guillermo del Toro | Ron Perlman, John Hurt, Selma Blair, Rupert Ev... | United States | December 1, 2018 | 2004 | PG-13 | 122 min | Action & Adventure, Cult Movies, Sci-Fi & Fantasy | This fast-paced action flick tells the dark st... |
| 7088 | s7089 | Movie | Inuyasha the Movie - L'isola del fuoco scarlatto | Toshiya Shinohara | Kappei Yamaguchi, Satsuki Yukino, Koji Tsujita... | Japan | September 1, 2017 | 2004 | TV-PG | 88 min | Action & Adventure, Anime Features, Internatio... | Ai, a young half-demon who has escaped from Ho... |
| 7198 | s7199 | Movie | Kill Bill: Vol. 2 | Quentin Tarantino | Uma Thurman, David Carradine, Michael Madsen, ... | United States | January 1, 2020 | 2004 | R | 137 min | Action & Adventure | The Bride has three left on her rampage list: ... |
| 7239 | s7240 | Movie | Kung Fu Hustle | Stephen Chow | Stephen Chow, Yuen Wah, Yuen Qiu, Lam Chi-chun... | Hong Kong, China, United States | April 1, 2020 | 2004 | R | 99 min | Action & Adventure, Comedies, Cult Movies | Sing, a mobster in 1940s China, longs to be as... |
| 7249 | s7250 | Movie | Kyun! Ho Gaya Na | Samir Karnik | Aishwarya Rai Bachchan, Vivek Oberoi, Amitabh ... | India | March 1, 2018 | 2004 | TV-PG | 165 min | International Movies, Romantic Movies | Cinematic lovebirds Aishwarya Rai and Vivek Ob... |
| 7460 | s7461 | Movie | Miracle | Gavin O'Connor | Kurt Russell, Patricia Clarkson, Noah Emmerich... | Canada, United States | June 1, 2018 | 2004 | PG | 136 min | Children & Family Movies, Dramas, Sports Movies | U.S. hockey coach Herb Brooks unites a motley ... |
| 7524 | s7525 | Movie | Mujhse Shaadi Karogi | David Dhawan | Rajpal Yadav, Amrish Puri, Kader Khan, Shashi ... | India | December 31, 2019 | 2004 | TV-PG | 158 min | Comedies, International Movies, Romantic Movies | Samir must overcome a hostile horoscope, a hot... |
| 7564 | s7565 | Movie | National Treasure | Jon Turteltaub | Nicolas Cage, Diane Kruger, Justin Bartha, Sea... | United States | June 1, 2018 | 2004 | PG | 131 min | Action & Adventure, Children & Family Movies | Modern treasure hunters search for a chest of ... |
| 7579 | s7580 | Movie | New York Minute | Dennie Gordon | Mary-Kate Olsen, Ashley Olsen, Eugene Levy, An... | United States | January 1, 2020 | 2004 | PG | 91 min | Children & Family Movies, Comedies | When bickering teenage twins accidentally land... |
| 7639 | s7640 | Movie | Ocean's Twelve | Steven Soderbergh | George Clooney, Brad Pitt, Matt Damon, Catheri... | United States | October 1, 2019 | 2004 | PG-13 | 125 min | Action & Adventure, Comedies | Danny Ocean reunites with his old flame and th... |
| 7902 | s7903 | Movie | Run | Jeeva | Abhishek Bachchan, Bhoomika Chawla, Mahesh Man... | India | March 1, 2018 | 2004 | TV-14 | 134 min | Action & Adventure, International Movies, Musi... | Siddharth falls in love with beautiful Jhanvi.... |
| 8013 | s8014 | Movie | Shutter | Banjong Pisanthanakun, Parkpoom Wongpoom | Ananda Everingham, Natthaweeranuch Thongmee, A... | Thailand | September 5, 2018 | 2004 | TV-MA | 96 min | Horror Movies, International Movies | After killing a young girl in a hit-and-run ac... |
| 8037 | s8038 | Movie | Sleepover | Joe Nussbaum | Alexa PenaVega, Mika Boorem, Jane Lynch, Sam H... | United States | March 1, 2020 | 2004 | PG | 89 min | Comedies, Romantic Movies | As high school approaches, four best friends h... |
| 8452 | s8453 | Movie | The Phantom of the Opera | Joel Schumacher | Gerard Butler, Emmy Rossum, Patrick Wilson, Mi... | United Kingdom, United States | June 1, 2019 | 2004 | PG-13 | 141 min | Dramas, Music & Musicals, Romantic Movies | In 1870, a disfigured recluse roams beneath a ... |
| 8461 | s8462 | Movie | The Polar Express | Robert Zemeckis | Tom Hanks, Leslie Zemeckis, Eddie Deezen, Nona... | United States | January 1, 2021 | 2004 | G | 100 min | Children & Family Movies | In this warm-hearted tale, a young boy's faith... |
| 8463 | s8464 | Movie | The President's Barber | Chan-sang Lim | Kang-ho Song, So-ri Moon, Jae-eung Lee, Yeong-... | South Korea | October 1, 2017 | 2004 | TV-MA | 116 min | Comedies, Dramas, International Movies | The personal barber to the president, as well ... |
| 8465 | s8466 | Movie | The Prince & Me | Martha Coolidge | Julia Stiles, Luke Mably, Ben Miller, Miranda ... | United States, Czech Republic | October 1, 2020 | 2004 | PG | 111 min | Comedies, Romantic Movies | A hardworking Wisconsin college student falls ... |
| 8624 | s8625 | Movie | Tremors 4: The Legend Begins | S.S. Wilson | Michael Gross, Sara Botsford, Billy Drago, Bre... | United States | January 1, 2020 | 2004 | PG-13 | 101 min | Comedies, Horror Movies, Sci-Fi & Fantasy | Residents of a abandoned mining town attempt t... |
| 8682 | s8683 | Movie | Vizontele Tuuba | Yılmaz Erdoğan | Yılmaz Erdoğan, Tarık Akan, Altan Erkekli, Cez... | Turkey | March 10, 2017 | 2004 | NR | 106 min | Comedies, Dramas, International Movies | With civil war looming, a TV-obsessed Turkish ... |
netflix[(netflix['type'] == 'Movie' ) & (netflix['release_year'] == 2004)].shape
(55, 12)
netflix_copy.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | September 25, 2021 | 2020 | PG-13 | 90 min | As her father nears the end of his life, filmm... | Documentaries | NaN | NaN |
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | After crossing paths at a party, a Cape Town t... | International TV Shows | TV Dramas | TV Mysteries |
netflix_copy[(netflix_copy['type']=='TV Show') & (netflix_copy['country']=='United States')]['title']
15 Dear White People
40 He-Man and the Masters of the Universe
55 Nailed It
67 Saved by the Bell
82 Lucifer
...
8710 Weeds
8726 When Calls the Heart
8747 Winsanity
8755 Women Behind Bars
8780 Yo-Kai Watch
Name: title, Length: 754, dtype: object
netflix_copy[(netflix_copy['type']=='TV Show') & (netflix_copy['country']=='United States')]['title'].shape
(754,)
Obeservation:
netflix_copy.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | September 25, 2021 | 2020 | PG-13 | 90 min | As her father nears the end of his life, filmm... | Documentaries | NaN | NaN |
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | After crossing paths at a party, a Cape Town t... | International TV Shows | TV Dramas | TV Mysteries |
netflix_copy[netflix_copy['cast'].str.contains('Salman Khan')]
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1441 | s1442 | Movie | Hello Brother | Sohail Khan | Salman Khan, Arbaaz Khan, Rani Mukerji, Johny ... | India | January 4, 2021 | 1999 | TV-14 | 126 min | After receiving a heart transplant from a murd... | Action & Adventure | Comedies | International Movies |
| 1674 | s1675 | Movie | Bodyguard | Siddique | Salman Khan, Kareena Kapoor, Raj Babbar, Asran... | India | November 19, 2020 | 2011 | TV-14 | 130 min | Irked by her bodyguard, an heiress invents a s... | Action & Adventure | Comedies | International Movies |
| 2339 | s2340 | Movie | Prem Ratan Dhan Payo | Sooraj R. Barjatya | Salman Khan, Sonam Kapoor, Anupam Kher, Neil N... | India | June 25, 2020 | 2015 | TV-14 | 164 min | While recovering from an assassination attempt... | Action & Adventure | Dramas | International Movies |
| 2545 | s2546 | Movie | Andaz Apna Apna | Rajkumar Santoshi | Aamir Khan, Salman Khan, Raveena Tandon, Karis... | India | May 11, 2020 | 1994 | TV-14 | 160 min | Broke and with no concrete plans for the futur... | Action & Adventure | Comedies | Cult Movies |
| 2734 | s2735 | Movie | Kuch Kuch Hota Hai | Karan Johar | Shah Rukh Khan, Kajol, Rani Mukerji, Farida Ja... | India | April 1, 2020 | 1998 | TV-14 | 185 min | Per her mother’s last wish, a girl sets out to... | Comedies | Dramas | International Movies |
| 2756 | s2757 | Movie | Paharganj | Rakesh Ranjan Kumar | Lorena Franco, Bijesh Jayarajan, Neet Chowdhar... | India | March 31, 2020 | 2019 | TV-MA | 107 min | In the underbelly of a Delhi neighborhood, a w... | Dramas | Independent Movies | International Movies |
| 2957 | s2958 | Movie | Hum Aapke Hain Koun | Sooraj R. Barjatya | Madhuri Dixit, Salman Khan, Mohnish Bahl, Renu... | India | February 1, 2020 | 1994 | TV-14 | 193 min | Although Nisha falls for Prem, she agrees to m... | Classic Movies | Dramas | International Movies |
| 2969 | s2970 | Movie | Together For Eternity | Sooraj R. Barjatya | Salman Khan, Karisma Kapoor, Saif Ali Khan, Ta... | India | February 1, 2020 | 1999 | TV-G | 176 min | A scheming matriarch plots to cut off her disa... | Dramas | International Movies | Music & Musicals |
| 4729 | s4730 | Movie | Main aurr Mrs. Khanna | Prem Soni | Salman Khan, Kareena Kapoor, Sohail Khan, Prei... | India | August 2, 2018 | 2009 | TV-14 | 109 min | A financially troubled Indian man heads to Sin... | International Movies | Music & Musicals | Romantic Movies |
| 5718 | s5719 | Movie | Mumbai Cha Raja | Manjeet Singh | Rahul Bairagi, Arbaaz Khan, Tejas Parvatkar, D... | India | November 15, 2016 | 2012 | TV-MA | 77 min | This coming-of-age tale follows Rahul, a young... | Dramas | Independent Movies | International Movies |
| 6440 | s6441 | Movie | Chal Mere Bhai | David Dhawan | Sanjay Dutt, Salman Khan, Karisma Kapoor, Dali... | India | December 31, 2019 | 2000 | TV-14 | 132 min | When a secretary saves her tycoon boss's life,... | Comedies | International Movies | Romantic Movies |
| 7022 | s7023 | Movie | Hum Saath-Saath Hain | Sooraj R. Barjatya | Salman Khan, Karisma Kapoor, Saif Ali Khan, Ta... | India | January 1, 2018 | 1999 | TV-G | 176 min | A scheming matriarch plots to cut off her disa... | Dramas | International Movies | Music & Musicals |
| 7109 | s7110 | Movie | Jaan-E-Mann: Let's Fall in Love... Again | Shirish Kunder | Salman Khan, Akshay Kumar, Preity Zinta, Anupa... | India | December 31, 2019 | 2006 | TV-14 | 163 min | To avoid alimony payments, an aspiring actor s... | Dramas | International Movies | Romantic Movies |
| 7144 | s7145 | Movie | Judwaa | David Dhawan | Salman Khan, Karisma Kapoor, Rambha, Kader Kha... | India | December 31, 2019 | 1997 | TV-14 | 133 min | Separated at birth, a pair of identical twins ... | Comedies | International Movies | Romantic Movies |
| 7360 | s7361 | Movie | Lucky: No Time for Love | Radhika Rao, Vinay Sapru | Salman Khan, Sneha Ullal, Mithun Chakraborty, ... | India | November 15, 2017 | 2005 | TV-14 | 131 min | During an uprising in Russia's St. Petersburg,... | Dramas | International Movies | Romantic Movies |
| 7386 | s7387 | Movie | Maine Pyaar Kyun Kiya | David Dhawan | Salman Khan, Sushmita Sen, Sohail Khan, Katrin... | India | December 31, 2019 | 2005 | TV-14 | 137 min | After lying to his girlfriend, orthopedic surg... | Comedies | International Movies | Music & Musicals |
| 7387 | s7388 | Movie | Maine Pyar Kiya | Sooraj R. Barjatya | Salman Khan, Bhagyashree, Alok Nath, Rajeev Ve... | India | January 1, 2018 | 1989 | TV-PG | 192 min | When the son of a wealthy businessman and the ... | Dramas | International Movies | Music & Musicals |
| 7524 | s7525 | Movie | Mujhse Shaadi Karogi | David Dhawan | Rajpal Yadav, Amrish Puri, Kader Khan, Shashi ... | India | December 31, 2019 | 2004 | TV-PG | 158 min | Samir must overcome a hostile horoscope, a hot... | Comedies | International Movies | Romantic Movies |
| 7590 | s7591 | Movie | No Entry | Anees Bazmee | Anil Kapoor, Salman Khan, Fardeen Khan, Bipash... | India | March 1, 2018 | 2005 | TV-PG | 161 min | After a prank goes sideways, three buddies fin... | Comedies | International Movies | NaN |
| 7837 | s7838 | Movie | Ready | Anees Bazmee | Salman Khan, Asin, Paresh Rawal, Mahesh Manjre... | India | October 22, 2017 | 2011 | TV-PG | 144 min | Bollywood superstar Salman Khan plays Prem, an... | Comedies | International Movies | Romantic Movies |
netflix_copy[netflix_copy['cast'].str.contains('Salman Khan')].shape
(20, 14)
Obeservation:
netflix_copy.head(2)
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | Movie | Dick Johnson Is Dead | Kirsten Johnson | Unknown | United States | September 25, 2021 | 2020 | PG-13 | 90 min | As her father nears the end of his life, filmm... | Documentaries | NaN | NaN |
| 1 | s2 | TV Show | Blood & Water | Unknown | Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban... | South Africa | September 24, 2021 | 2021 | TV-MA | 2 Seasons | After crossing paths at a party, a Cape Town t... | International TV Shows | TV Dramas | TV Mysteries |
netflix_copy[(netflix_copy['type']=='Movie') & (netflix_copy['country']=='India') & (netflix_copy['rating']=='TV-14')]
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | description | Genre 1 | Genre 2 | Genre 3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24 | s25 | Movie | Jeans | S. Shankar | Prashanth, Aishwarya Rai Bachchan, Sri Lakshmi... | India | September 21, 2021 | 1998 | TV-14 | 166 min | When the father of the man she loves insists t... | Comedies | International Movies | Romantic Movies |
| 105 | s106 | Movie | Angamaly Diaries | Lijo Jose Pellissery | Antony Varghese, Reshma Rajan, Binny Rinky Ben... | India | September 5, 2021 | 2017 | TV-14 | 128 min | After growing up amidst the gang wars of his h... | Action & Adventure | Comedies | Dramas |
| 114 | s115 | Movie | Anjaam | Rahul Rawail | Madhuri Dixit, Shah Rukh Khan, Tinnu Anand, Jo... | India | September 2, 2021 | 1994 | TV-14 | 143 min | A wealthy industrialist’s dangerous obsession ... | Dramas | International Movies | Thrillers |
| 118 | s119 | Movie | Gurgaon | Shanker Raman | Akshay Oberoi, Pankaj Tripathi, Ragini Khanna,... | India | September 2, 2021 | 2017 | TV-14 | 106 min | When the daughter of a wealthy family returns ... | Dramas | International Movies | Thrillers |
| 126 | s127 | Movie | Shikara | Vidhu Vinod Chopra | Aadil Khan, Sadia Khateeb, Zain Khan Durrani, ... | India | September 2, 2021 | 2020 | TV-14 | 115 min | A couple must strive to remain resilient after... | Dramas | International Movies | Romantic Movies |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 8770 | s8771 | Movie | Yaadein | Subhash Ghai | Jackie Shroff, Hrithik Roshan, Kareena Kapoor,... | India | March 1, 2018 | 2001 | TV-14 | 171 min | Two young lovers set out to overcome the obsta... | Dramas | International Movies | Romantic Movies |
| 8771 | s8772 | Movie | Yaara O Dildaara | Ksshitij Chaudhary | Harbhajan Mann, Tulip Joshi, Kabir Bedi, Gulza... | India | November 1, 2017 | 2011 | TV-14 | 132 min | The patriarch of a wealthy family with one ind... | Dramas | International Movies | Music & Musicals |
| 8772 | s8773 | Movie | Yamla Pagla Deewana 2 | Sangeeth Sivan | Dharmendra, Sunny Deol, Bobby Deol, Neha Sharm... | India | May 1, 2017 | 2013 | TV-14 | 147 min | Up to his old tricks, con man Dharam poses as ... | Action & Adventure | Comedies | International Movies |
| 8799 | s8800 | Movie | Zenda | Avadhoot Gupte | Santosh Juvekar, Siddharth Chandekar, Sachit P... | India | February 15, 2018 | 2009 | TV-14 | 120 min | A change in the leadership of a political part... | Dramas | International Movies | NaN |
| 8806 | s8807 | Movie | Zubaan | Mozez Singh | Vicky Kaushal, Sarah-Jane Dias, Raaghav Chanan... | India | March 2, 2019 | 2015 | TV-14 | 111 min | A scrappy but poor boy worms his way into a ty... | Dramas | International Movies | Music & Musicals |
526 rows × 14 columns
netflix_copy[(netflix_copy['type']=='Movie') & (netflix_copy['country']=='India') & (netflix_copy['rating']=='TV-14')].shape
(526, 14)
Observation:
We can see that netflix have 69% movies while 30% TV Shows
Maximum count of ratings included TV-MA (Mature Audiences) and TV-14 (Parents strongly cautioned) for both Movies and TV shows
17 types of ratings on netflix
From the above we can see that with passing years more movies are being made year by year The above data shows that there is a sudden increase in the creation of movies in year 2016 as compared to year 2015
Audience likes to watched mostly movies(96.88% ) over TV shows(3.12%)
July has maximum numbers of movies release. Hence July is the best month for releasing content.
The growth in contents are higher in the first three months and the last three months of the year. Least number of contents are added in the month of February.
Genre1 has been watched maximum times.
For "Sex Education" the show id is s33 and No director.
There are 55 movies released in year 2004.
There are 754 TV shows that were released in United States only.
There are 20 movies where case is Salman Khan.
526 movies got the "TV-14" rating in India.
Considering that Netflix has a higher focus on movies than TV shows, it could be beneficial for Netflix to continue investing in movie production. This can involve acquiring more movie titles, producing original movies, and partnering with renowned filmmakers and production companies to strengthen their movie catalog.
Given that TV-MA and TV-14 ratings are popular among Netflix viewers, it would be advantageous for Netflix to continue offering a diverse range of content targeted towards mature audiences. This can involve acquiring or producing more content in these rating categories to cater to the preferences of their subscribers.
Netflix can capitalize on the increasing trend of movie production by actively scouting for new and engaging movie projects. This can involve collaborations with talented directors, screenwriters, and actors to create high-quality movies that resonate with global audiences.
While movies are more popular among the audience, Netflix should not neglect TV shows entirely. They can consider strategic investments in original TV show productions to cater to the segment of their subscribers who enjoy TV series. This can involve partnering with popular showrunners and creators to develop compelling and binge-worthy TV content.
Based on the data showing the higher number of movie releases in July and the growth pattern in content additions, Netflix can prioritize the release of major movies and content expansions during the first three months and the last three months of the year. This can help maximize viewership and subscriber engagement during these periods.
Netflix can analyze the data further to identify the most-watched genres (Genre1) and leverage this information to curate personalized recommendations for their subscribers. By understanding the viewing preferences of their audience, Netflix can enhance the user experience by suggesting relevant content from the popular genres.
It would be beneficial for Netflix to provide complete and accurate metadata for all their content, including the show "Sex Education." Having accurate show IDs and director information helps improve the overall browsing experience for users and ensures consistent and comprehensive content information.
Considering the number of movies released in 2004 (55), Netflix can explore highlighting classic and noteworthy movies from that year to attract cinephiles and those interested in retro content. Creating curated collections or featuring a "Throwback" category can engage viewers who appreciate films from specific years or eras.
With a significant number of TV shows released exclusively in the United States, Netflix can continue investing in regional content production and acquisitions. By catering to specific markets, they can attract and retain subscribers in the United States and strengthen their position in the local streaming landscape.
The presence of movies featuring Salman Khan indicates an existing fan base for the actor. Netflix can leverage this popularity by promoting and marketing these movies prominently, targeting Salman Khan's fans, and exploring collaborations for exclusive content featuring the actor.
Given the high number of movies with a "TV-14" rating in India, Netflix can further expand its content library catering to Indian viewers. By acquiring or producing more content that aligns with Indian tastes and preferences, Netflix can strengthen its position in the Indian market and attract a larger audience.
These recommendations are based on the insights provided, and it's important for Netflix to conduct in-depth market research and analysis to validate and refine these recommendations further.